/*
 Navicat Premium Data Transfer

 Source Server         : cool
 Source Server Type    : MySQL
 Source Server Version : 50726
 Source Host           : 47.112.101.42:3306
 Source Schema         : cool

 Target Server Type    : MySQL
 Target Server Version : 50726
 File Encoding         : 65001

 Date: 25/09/2019 20:13:46
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for sys_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_log`;
CREATE TABLE `sys_log` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `createTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updateTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `userId` bigint(20) DEFAULT NULL,
  `action` varchar(255) NOT NULL,
  `ip` varchar(255) DEFAULT NULL,
  `params` text,
  `ipAddr` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_7217d5c9de1b05ce4ad42ecbee` (`createTime`),
  KEY `IDX_ff05f06b91d250e91bb4232163` (`userId`),
  KEY `IDX_b90847f09ea57036ce3ff8608a` (`ip`),
  KEY `IDX_5a45ffff94248c8d1b4fa6a482` (`ipAddr`),
  KEY `IDX_7348bae9165c893fc91281b826` (`action`)
) ENGINE=InnoDB AUTO_INCREMENT=703 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of sys_log
-- ----------------------------
BEGIN;
INSERT INTO `sys_log` VALUES (690, '2019-09-25 20:13:17.568851', '2019-09-25 20:13:17.568851', 1, '/admin/sys/menu/list', '211.161.248.242', '{\"t\":\"1569413456000\"}', '中国上海');
INSERT INTO `sys_log` VALUES (691, '2019-09-25 20:13:18.434694', '2019-09-25 20:13:18.434694', 1, '/admin/sys/menu/list', '211.161.248.242', '{\"t\":\"1569413457000\"}', '中国上海');
INSERT INTO `sys_log` VALUES (692, '2019-09-25 20:13:25.811900', '2019-09-25 20:13:25.811900', 1, '/admin/sys/menu/info', '211.161.248.242', '{\"id\":\"34\",\"t\":\"1569413464000\"}', '中国上海');
INSERT INTO `sys_log` VALUES (693, '2019-09-25 20:13:25.816031', '2019-09-25 20:13:25.816031', 1, '/admin/sys/menu/list', '211.161.248.242', '{\"t\":\"1569413464000\"}', '中国上海');
INSERT INTO `sys_log` VALUES (694, '2019-09-25 20:13:28.833632', '2019-09-25 20:13:28.833632', 1, '/admin/sys/role/page', '211.161.248.242', '{\"page\":\"1\",\"size\":\"20\",\"order\":\"createTime\",\"sort\":\"desc\",\"t\":\"1569413467000\"}', '中国上海');
INSERT INTO `sys_log` VALUES (695, '2019-09-25 20:13:31.673002', '2019-09-25 20:13:31.673002', 1, '/admin/sys/user/page', '211.161.248.242', '{\"page\":\"1\",\"size\":\"20\",\"order\":\"createTime\",\"sort\":\"desc\",\"t\":\"1569413470000\"}', '中国上海');
INSERT INTO `sys_log` VALUES (696, '2019-09-25 20:13:33.798147', '2019-09-25 20:13:33.798147', 1, '/admin/sys/menu/list', '211.161.248.242', '{\"t\":\"1569413472000\"}', '中国上海');
INSERT INTO `sys_log` VALUES (697, '2019-09-25 20:13:34.417162', '2019-09-25 20:13:34.417162', 1, '/admin/sys/user/page', '211.161.248.242', '{\"page\":\"1\",\"size\":\"20\",\"order\":\"createTime\",\"sort\":\"desc\",\"t\":\"1569413473000\"}', '中国上海');
INSERT INTO `sys_log` VALUES (698, '2019-09-25 20:13:34.907880', '2019-09-25 20:13:34.907880', 1, '/admin/sys/role/page', '211.161.248.242', '{\"page\":\"1\",\"size\":\"20\",\"order\":\"createTime\",\"sort\":\"desc\",\"t\":\"1569413473000\"}', '中国上海');
INSERT INTO `sys_log` VALUES (699, '2019-09-25 20:13:35.387586', '2019-09-25 20:13:35.387586', 1, '/admin/sys/menu/list', '211.161.248.242', '{\"t\":\"1569413474000\"}', '中国上海');
INSERT INTO `sys_log` VALUES (700, '2019-09-25 20:13:35.723869', '2019-09-25 20:13:35.723869', 1, '/admin/sys/user/page', '211.161.248.242', '{\"page\":\"1\",\"size\":\"20\",\"order\":\"createTime\",\"sort\":\"desc\",\"t\":\"1569413474000\"}', '中国上海');
INSERT INTO `sys_log` VALUES (701, '2019-09-25 20:13:37.698719', '2019-09-25 20:13:37.698719', 1, '/admin/sys/log/page', '211.161.248.242', '{\"page\":\"1\",\"size\":\"20\",\"order\":\"createTime\",\"sort\":\"desc\",\"t\":\"1569413476000\"}', '中国上海');
INSERT INTO `sys_log` VALUES (702, '2019-09-25 20:13:46.204687', '2019-09-25 20:13:46.204687', 1, '/admin/sys/log/page', '211.161.248.242', '{\"page\":\"1\",\"size\":\"20\",\"order\":\"createTime\",\"keyWord\":\"\",\"sort\":\"desc\",\"t\":\"1569413485000\"}', '中国上海');
COMMIT;

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `createTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updateTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `parentId` bigint(20) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `router` varchar(255) DEFAULT NULL,
  `perms` varchar(255) DEFAULT NULL,
  `type` tinyint(4) NOT NULL DEFAULT '0',
  `icon` varchar(255) DEFAULT NULL,
  `orderNum` int(11) NOT NULL DEFAULT '0',
  `viewPath` varchar(255) DEFAULT NULL,
  `keepAlive` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `IDX_1616b35781fbecc494f496498f` (`createTime`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu` VALUES (1, '2019-09-11 11:14:44.000000', '2019-09-25 15:12:47.000000', NULL, '工作台', '/', NULL, 0, 'icon-gongzuotai', 2, NULL, 1);
INSERT INTO `sys_menu` VALUES (2, '2019-09-11 11:14:47.000000', '2019-09-18 15:37:18.000000', NULL, '系统', '/sys', NULL, 0, 'icon-systemfill', 2, NULL, 1);
INSERT INTO `sys_menu` VALUES (3, '2019-09-11 11:14:49.000000', '2019-09-18 15:40:36.000000', NULL, '教程', '/tutorial', NULL, 0, 'icon-weibiaoti4', 3, NULL, 1);
INSERT INTO `sys_menu` VALUES (8, '2019-09-11 23:19:57.053631', '2019-09-12 15:53:39.000000', 27, '菜单列表', '/sys/menu', NULL, 1, 'icon-menu', 2, 'views/system/menu/index.vue', 1);
INSERT INTO `sys_menu` VALUES (10, '2019-09-12 00:19:27.325922', '2019-09-12 00:19:27.325922', 8, '新增', NULL, 'sys:menu:add', 2, NULL, 1, NULL, 0);
INSERT INTO `sys_menu` VALUES (11, '2019-09-12 00:19:51.101514', '2019-09-12 00:19:51.101514', 8, '删除', NULL, 'sys:menu:delete', 2, NULL, 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (12, '2019-09-12 00:20:05.150021', '2019-09-12 00:20:05.150021', 8, '修改', NULL, 'sys:menu:update', 2, NULL, 3, NULL, 0);
INSERT INTO `sys_menu` VALUES (13, '2019-09-12 00:20:19.341206', '2019-09-12 00:20:19.341206', 8, '查询', NULL, 'sys:menu:page,sys:menu:list,sys:menu:info', 2, NULL, 4, NULL, 0);
INSERT INTO `sys_menu` VALUES (17, '2019-09-12 00:31:25.334489', '2019-09-15 23:45:57.000000', 27, '用户列表', '/sys/user', NULL, 1, 'icon-user', 1, 'views/system/user/index.vue', 1);
INSERT INTO `sys_menu` VALUES (18, '2019-09-12 00:32:21.769338', '2019-09-12 00:32:21.769338', 17, '新增', NULL, 'sys:user:add', 2, NULL, 1, NULL, 0);
INSERT INTO `sys_menu` VALUES (19, '2019-09-12 00:32:34.578645', '2019-09-12 00:32:34.578645', 17, '删除', NULL, 'sys:user:delete', 2, NULL, 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (20, '2019-09-12 00:32:47.291027', '2019-09-12 00:32:47.291027', 17, '修改', NULL, 'sys:user:update', 2, NULL, 3, NULL, 0);
INSERT INTO `sys_menu` VALUES (21, '2019-09-12 00:33:00.053653', '2019-09-12 00:33:00.053653', 17, '查询', NULL, 'sys:user:page,sys:user:list,sys:user:info', 2, NULL, 4, NULL, 0);
INSERT INTO `sys_menu` VALUES (22, '2019-09-12 00:34:01.141743', '2019-09-15 23:47:27.000000', 27, '角色列表', '/sys/role', NULL, 1, 'icon-role', 3, 'views/system/role/index.vue', 1);
INSERT INTO `sys_menu` VALUES (23, '2019-09-12 00:34:23.459460', '2019-09-12 00:34:23.459460', 22, '新增', NULL, 'sys:role:add', 2, NULL, 1, NULL, 0);
INSERT INTO `sys_menu` VALUES (24, '2019-09-12 00:34:40.523471', '2019-09-12 00:34:40.523471', 22, '删除', NULL, 'sys:role:delete', 2, NULL, 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (25, '2019-09-12 00:34:53.306692', '2019-09-12 00:34:53.306692', 22, '修改', NULL, 'sys:role:update', 2, NULL, 3, NULL, 0);
INSERT INTO `sys_menu` VALUES (26, '2019-09-12 00:35:05.024307', '2019-09-12 00:35:05.024307', 22, '查询', NULL, 'sys:role:page,sys:role:list,sys:role:info', 2, NULL, 4, NULL, 0);
INSERT INTO `sys_menu` VALUES (27, '2019-09-12 15:52:44.342387', '2019-09-15 22:11:56.000000', 2, '权限管理', NULL, NULL, 0, 'icon-permission', 1, NULL, 0);
INSERT INTO `sys_menu` VALUES (28, '2019-09-12 17:19:16.827254', '2019-09-15 22:12:08.000000', 2, '系统监控', NULL, NULL, 0, 'icon-monitor', 2, NULL, 0);
INSERT INTO `sys_menu` VALUES (29, '2019-09-12 17:35:51.003534', '2019-09-24 10:29:53.000000', 28, '日志列表', '/sys/log', '1', 1, 'icon-log', 1, 'views/system/log/index.vue', 0);
INSERT INTO `sys_menu` VALUES (30, '2019-09-12 17:37:03.519372', '2019-09-12 17:56:50.000000', 29, '权限', NULL, 'sys:log:page,sys:log:clear', 2, NULL, 1, NULL, 0);
INSERT INTO `sys_menu` VALUES (34, '2019-09-18 00:30:56.637811', '2019-09-25 01:23:01.000000', 1, 'UI - 组件库', '/ui-components', '0', 1, 'icon-activityfill', 1, 'views/workbench/ui-components.vue', 0);
INSERT INTO `sys_menu` VALUES (35, '2019-09-18 00:43:37.952662', '2019-09-24 21:24:49.000000', 3, '文档', '/tutorial/doc', '0', 1, 'icon-log', 1, 'https://docs.cool-admin.com/#/', 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `createTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updateTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `name` varchar(255) NOT NULL,
  `label` varchar(255) DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `IDX_223de54d6badbe43a5490450c3` (`name`),
  UNIQUE KEY `IDX_f2d07943355da93c3a8a1c411a` (`label`),
  KEY `IDX_77917ed69a116ebf458c681829` (`createTime`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of sys_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_role` VALUES (1, '2019-09-11 23:04:35.193681', '2019-09-11 23:04:35.193681', '超管', 'admin', NULL);
INSERT INTO `sys_role` VALUES (22, '2019-09-25 00:54:25.262771', '2019-09-25 10:25:14.000000', '角色A', 'A', '测试');
INSERT INTO `sys_role` VALUES (23, '2019-09-25 00:54:29.269843', '2019-09-25 10:25:18.000000', '角色B', 'B', '测试');
INSERT INTO `sys_role` VALUES (24, '2019-09-25 00:54:35.285304', '2019-09-25 10:25:22.000000', '角色C', 'C', '测试');
COMMIT;

-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE `sys_role_menu` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `createTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updateTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `roleId` bigint(20) NOT NULL,
  `menuId` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_84d8a9d8befebc08fb3be08f1a` (`createTime`)
) ENGINE=InnoDB AUTO_INCREMENT=763 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_role_menu` VALUES (89, '2019-09-24 10:48:52.467519', '2019-09-24 10:48:52.467519', 3, 1);
INSERT INTO `sys_role_menu` VALUES (90, '2019-09-24 10:48:52.557034', '2019-09-24 10:48:52.557034', 3, 34);
INSERT INTO `sys_role_menu` VALUES (91, '2019-09-24 10:48:52.660929', '2019-09-24 10:48:52.660929', 3, 2);
INSERT INTO `sys_role_menu` VALUES (92, '2019-09-24 10:48:52.777932', '2019-09-24 10:48:52.777932', 3, 27);
INSERT INTO `sys_role_menu` VALUES (93, '2019-09-24 10:48:52.879811', '2019-09-24 10:48:52.879811', 3, 17);
INSERT INTO `sys_role_menu` VALUES (94, '2019-09-24 10:48:52.970470', '2019-09-24 10:48:52.970470', 3, 18);
INSERT INTO `sys_role_menu` VALUES (95, '2019-09-24 10:48:53.076595', '2019-09-24 10:48:53.076595', 3, 19);
INSERT INTO `sys_role_menu` VALUES (96, '2019-09-24 10:48:53.197894', '2019-09-24 10:48:53.197894', 3, 20);
INSERT INTO `sys_role_menu` VALUES (97, '2019-09-24 10:48:53.315433', '2019-09-24 10:48:53.315433', 3, 21);
INSERT INTO `sys_role_menu` VALUES (98, '2019-09-24 10:48:53.443267', '2019-09-24 10:48:53.443267', 3, 8);
INSERT INTO `sys_role_menu` VALUES (99, '2019-09-24 10:48:53.545574', '2019-09-24 10:48:53.545574', 3, 10);
INSERT INTO `sys_role_menu` VALUES (100, '2019-09-24 10:48:53.635436', '2019-09-24 10:48:53.635436', 3, 11);
INSERT INTO `sys_role_menu` VALUES (101, '2019-09-24 10:48:53.739326', '2019-09-24 10:48:53.739326', 3, 12);
INSERT INTO `sys_role_menu` VALUES (102, '2019-09-24 10:48:53.851149', '2019-09-24 10:48:53.851149', 3, 13);
INSERT INTO `sys_role_menu` VALUES (103, '2019-09-24 10:48:53.967937', '2019-09-24 10:48:53.967937', 3, 22);
INSERT INTO `sys_role_menu` VALUES (104, '2019-09-24 10:48:54.095735', '2019-09-24 10:48:54.095735', 3, 23);
INSERT INTO `sys_role_menu` VALUES (105, '2019-09-24 10:48:54.222146', '2019-09-24 10:48:54.222146', 3, 24);
INSERT INTO `sys_role_menu` VALUES (106, '2019-09-24 10:48:54.348489', '2019-09-24 10:48:54.348489', 3, 25);
INSERT INTO `sys_role_menu` VALUES (107, '2019-09-24 10:48:54.460685', '2019-09-24 10:48:54.460685', 3, 26);
INSERT INTO `sys_role_menu` VALUES (108, '2019-09-24 10:48:54.556885', '2019-09-24 10:48:54.556885', 3, 28);
INSERT INTO `sys_role_menu` VALUES (109, '2019-09-24 10:48:54.647511', '2019-09-24 10:48:54.647511', 3, 29);
INSERT INTO `sys_role_menu` VALUES (110, '2019-09-24 10:48:54.756336', '2019-09-24 10:48:54.756336', 3, 30);
INSERT INTO `sys_role_menu` VALUES (111, '2019-09-24 10:48:54.873173', '2019-09-24 10:48:54.873173', 3, 3);
INSERT INTO `sys_role_menu` VALUES (112, '2019-09-24 10:48:54.998758', '2019-09-24 10:48:54.998758', 3, 35);
INSERT INTO `sys_role_menu` VALUES (113, '2019-09-24 10:49:03.229459', '2019-09-24 10:49:03.229459', 2, 1);
INSERT INTO `sys_role_menu` VALUES (114, '2019-09-24 10:49:03.340162', '2019-09-24 10:49:03.340162', 2, 34);
INSERT INTO `sys_role_menu` VALUES (115, '2019-09-24 10:49:03.458236', '2019-09-24 10:49:03.458236', 2, 2);
INSERT INTO `sys_role_menu` VALUES (116, '2019-09-24 10:49:03.577590', '2019-09-24 10:49:03.577590', 2, 27);
INSERT INTO `sys_role_menu` VALUES (117, '2019-09-24 10:49:03.691109', '2019-09-24 10:49:03.691109', 2, 17);
INSERT INTO `sys_role_menu` VALUES (118, '2019-09-24 10:49:03.802532', '2019-09-24 10:49:03.802532', 2, 18);
INSERT INTO `sys_role_menu` VALUES (119, '2019-09-24 10:49:03.907959', '2019-09-24 10:49:03.907959', 2, 19);
INSERT INTO `sys_role_menu` VALUES (120, '2019-09-24 10:49:04.003739', '2019-09-24 10:49:04.003739', 2, 20);
INSERT INTO `sys_role_menu` VALUES (121, '2019-09-24 10:49:04.107757', '2019-09-24 10:49:04.107757', 2, 21);
INSERT INTO `sys_role_menu` VALUES (122, '2019-09-24 10:49:04.227512', '2019-09-24 10:49:04.227512', 2, 8);
INSERT INTO `sys_role_menu` VALUES (123, '2019-09-24 10:49:04.341716', '2019-09-24 10:49:04.341716', 2, 10);
INSERT INTO `sys_role_menu` VALUES (124, '2019-09-24 10:49:04.452449', '2019-09-24 10:49:04.452449', 2, 11);
INSERT INTO `sys_role_menu` VALUES (125, '2019-09-24 10:49:04.557443', '2019-09-24 10:49:04.557443', 2, 12);
INSERT INTO `sys_role_menu` VALUES (126, '2019-09-24 10:49:04.653254', '2019-09-24 10:49:04.653254', 2, 13);
INSERT INTO `sys_role_menu` VALUES (127, '2019-09-24 10:49:04.756598', '2019-09-24 10:49:04.756598', 2, 22);
INSERT INTO `sys_role_menu` VALUES (128, '2019-09-24 10:49:04.876996', '2019-09-24 10:49:04.876996', 2, 23);
INSERT INTO `sys_role_menu` VALUES (129, '2019-09-24 10:49:04.990503', '2019-09-24 10:49:04.990503', 2, 24);
INSERT INTO `sys_role_menu` VALUES (130, '2019-09-24 10:49:05.101961', '2019-09-24 10:49:05.101961', 2, 25);
INSERT INTO `sys_role_menu` VALUES (131, '2019-09-24 10:49:05.206586', '2019-09-24 10:49:05.206586', 2, 26);
INSERT INTO `sys_role_menu` VALUES (132, '2019-09-24 10:49:05.302415', '2019-09-24 10:49:05.302415', 2, 28);
INSERT INTO `sys_role_menu` VALUES (133, '2019-09-24 10:49:05.407244', '2019-09-24 10:49:05.407244', 2, 29);
INSERT INTO `sys_role_menu` VALUES (134, '2019-09-24 10:49:05.526579', '2019-09-24 10:49:05.526579', 2, 30);
INSERT INTO `sys_role_menu` VALUES (135, '2019-09-24 10:49:05.628459', '2019-09-24 10:49:05.628459', 2, 3);
INSERT INTO `sys_role_menu` VALUES (136, '2019-09-24 10:49:05.744732', '2019-09-24 10:49:05.744732', 2, 35);
INSERT INTO `sys_role_menu` VALUES (137, '2019-09-25 00:41:21.138065', '2019-09-25 00:41:21.138065', 18, 1);
INSERT INTO `sys_role_menu` VALUES (138, '2019-09-25 00:41:21.144458', '2019-09-25 00:41:21.144458', 18, 34);
INSERT INTO `sys_role_menu` VALUES (513, '2019-09-25 10:38:56.192320', '2019-09-25 10:38:56.192320', 24, 1);
INSERT INTO `sys_role_menu` VALUES (514, '2019-09-25 10:38:56.201377', '2019-09-25 10:38:56.201377', 24, 34);
INSERT INTO `sys_role_menu` VALUES (693, '2019-09-25 12:03:00.336599', '2019-09-25 12:03:00.336599', 23, 1);
INSERT INTO `sys_role_menu` VALUES (694, '2019-09-25 12:03:00.341601', '2019-09-25 12:03:00.341601', 23, 34);
INSERT INTO `sys_role_menu` VALUES (695, '2019-09-25 12:03:00.348238', '2019-09-25 12:03:00.348238', 23, 2);
INSERT INTO `sys_role_menu` VALUES (696, '2019-09-25 12:03:00.352960', '2019-09-25 12:03:00.352960', 23, 27);
INSERT INTO `sys_role_menu` VALUES (697, '2019-09-25 12:03:00.357547', '2019-09-25 12:03:00.357547', 23, 17);
INSERT INTO `sys_role_menu` VALUES (698, '2019-09-25 12:03:00.362170', '2019-09-25 12:03:00.362170', 23, 18);
INSERT INTO `sys_role_menu` VALUES (699, '2019-09-25 12:03:00.367931', '2019-09-25 12:03:00.367931', 23, 19);
INSERT INTO `sys_role_menu` VALUES (700, '2019-09-25 12:03:00.372562', '2019-09-25 12:03:00.372562', 23, 20);
INSERT INTO `sys_role_menu` VALUES (701, '2019-09-25 12:03:00.377181', '2019-09-25 12:03:00.377181', 23, 21);
INSERT INTO `sys_role_menu` VALUES (702, '2019-09-25 12:03:00.381803', '2019-09-25 12:03:00.381803', 23, 8);
INSERT INTO `sys_role_menu` VALUES (703, '2019-09-25 12:03:00.386753', '2019-09-25 12:03:00.386753', 23, 10);
INSERT INTO `sys_role_menu` VALUES (704, '2019-09-25 12:03:00.391970', '2019-09-25 12:03:00.391970', 23, 11);
INSERT INTO `sys_role_menu` VALUES (705, '2019-09-25 12:03:00.396679', '2019-09-25 12:03:00.396679', 23, 12);
INSERT INTO `sys_role_menu` VALUES (706, '2019-09-25 12:03:00.401243', '2019-09-25 12:03:00.401243', 23, 13);
INSERT INTO `sys_role_menu` VALUES (707, '2019-09-25 12:03:00.405864', '2019-09-25 12:03:00.405864', 23, 22);
INSERT INTO `sys_role_menu` VALUES (708, '2019-09-25 12:03:00.410895', '2019-09-25 12:03:00.410895', 23, 23);
INSERT INTO `sys_role_menu` VALUES (709, '2019-09-25 12:03:00.416110', '2019-09-25 12:03:00.416110', 23, 24);
INSERT INTO `sys_role_menu` VALUES (710, '2019-09-25 12:03:00.422158', '2019-09-25 12:03:00.422158', 23, 25);
INSERT INTO `sys_role_menu` VALUES (711, '2019-09-25 12:03:00.428037', '2019-09-25 12:03:00.428037', 23, 26);
INSERT INTO `sys_role_menu` VALUES (712, '2019-09-25 12:03:00.432460', '2019-09-25 12:03:00.432460', 23, 28);
INSERT INTO `sys_role_menu` VALUES (713, '2019-09-25 12:03:00.436905', '2019-09-25 12:03:00.436905', 23, 29);
INSERT INTO `sys_role_menu` VALUES (714, '2019-09-25 12:03:00.443258', '2019-09-25 12:03:00.443258', 23, 30);
INSERT INTO `sys_role_menu` VALUES (739, '2019-09-25 16:55:21.791714', '2019-09-25 16:55:21.791714', 22, 1);
INSERT INTO `sys_role_menu` VALUES (740, '2019-09-25 16:55:21.812059', '2019-09-25 16:55:21.812059', 22, 34);
INSERT INTO `sys_role_menu` VALUES (741, '2019-09-25 16:55:21.817036', '2019-09-25 16:55:21.817036', 22, 2);
INSERT INTO `sys_role_menu` VALUES (742, '2019-09-25 16:55:21.821361', '2019-09-25 16:55:21.821361', 22, 27);
INSERT INTO `sys_role_menu` VALUES (743, '2019-09-25 16:55:21.825553', '2019-09-25 16:55:21.825553', 22, 17);
INSERT INTO `sys_role_menu` VALUES (744, '2019-09-25 16:55:21.829938', '2019-09-25 16:55:21.829938', 22, 18);
INSERT INTO `sys_role_menu` VALUES (745, '2019-09-25 16:55:21.838846', '2019-09-25 16:55:21.838846', 22, 19);
INSERT INTO `sys_role_menu` VALUES (746, '2019-09-25 16:55:21.843671', '2019-09-25 16:55:21.843671', 22, 20);
INSERT INTO `sys_role_menu` VALUES (747, '2019-09-25 16:55:21.849529', '2019-09-25 16:55:21.849529', 22, 21);
INSERT INTO `sys_role_menu` VALUES (748, '2019-09-25 16:55:21.853876', '2019-09-25 16:55:21.853876', 22, 8);
INSERT INTO `sys_role_menu` VALUES (749, '2019-09-25 16:55:21.858235', '2019-09-25 16:55:21.858235', 22, 10);
INSERT INTO `sys_role_menu` VALUES (750, '2019-09-25 16:55:21.862929', '2019-09-25 16:55:21.862929', 22, 11);
INSERT INTO `sys_role_menu` VALUES (751, '2019-09-25 16:55:21.867081', '2019-09-25 16:55:21.867081', 22, 12);
INSERT INTO `sys_role_menu` VALUES (752, '2019-09-25 16:55:21.871325', '2019-09-25 16:55:21.871325', 22, 13);
INSERT INTO `sys_role_menu` VALUES (753, '2019-09-25 16:55:21.882016', '2019-09-25 16:55:21.882016', 22, 22);
INSERT INTO `sys_role_menu` VALUES (754, '2019-09-25 16:55:21.886344', '2019-09-25 16:55:21.886344', 22, 23);
INSERT INTO `sys_role_menu` VALUES (755, '2019-09-25 16:55:21.890901', '2019-09-25 16:55:21.890901', 22, 24);
INSERT INTO `sys_role_menu` VALUES (756, '2019-09-25 16:55:21.898225', '2019-09-25 16:55:21.898225', 22, 25);
INSERT INTO `sys_role_menu` VALUES (757, '2019-09-25 16:55:21.903144', '2019-09-25 16:55:21.903144', 22, 26);
INSERT INTO `sys_role_menu` VALUES (758, '2019-09-25 16:55:21.907266', '2019-09-25 16:55:21.907266', 22, 28);
INSERT INTO `sys_role_menu` VALUES (759, '2019-09-25 16:55:21.911613', '2019-09-25 16:55:21.911613', 22, 29);
INSERT INTO `sys_role_menu` VALUES (760, '2019-09-25 16:55:21.917317', '2019-09-25 16:55:21.917317', 22, 30);
INSERT INTO `sys_role_menu` VALUES (761, '2019-09-25 16:55:21.921993', '2019-09-25 16:55:21.921993', 22, 3);
INSERT INTO `sys_role_menu` VALUES (762, '2019-09-25 16:55:21.927005', '2019-09-25 16:55:21.927005', 22, 35);
COMMIT;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `username` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `passwordV` int(11) NOT NULL DEFAULT '1',
  `nickName` varchar(255) DEFAULT NULL,
  `headImg` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `remark` varchar(500) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `createTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updateTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  PRIMARY KEY (`id`),
  UNIQUE KEY `IDX_9e7164b2f1ea1348bc0eb0a7da` (`username`),
  KEY `IDX_7bef5cdb09432b1dfc46a063ce` (`phone`),
  KEY `IDX_167ca903c7c3418b8a4376e1a4` (`createTime`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` VALUES (1, '超级管理员', 'admin', 'e10adc3949ba59abbe56e057f20f883e', 1, '超管', 'https://cool-admin-test.oss-cn-shenzhen.aliyuncs.com/20190925/c3598110-df63-11e9-be78-256592ce3d00.jpg', '18000000000', '123456@qq.com', '备注', 1, '2019-06-25 10:20:20.600461', '2019-09-25 15:11:59.000000');
COMMIT;

-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `createTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `updateTime` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
  `userId` bigint(20) NOT NULL,
  `roleId` bigint(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_56d79fdd5342d2e35d7d9fec02` (`createTime`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_role` VALUES (1, '2019-09-11 23:05:18.890144', '2019-09-11 23:05:18.890144', 1, 1);
INSERT INTO `sys_user_role` VALUES (2, '2019-09-25 10:11:32.665042', '2019-09-25 10:11:32.665042', 2, 1);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
